clear all
set more off
cd ""

use "sample.dta", clear

* Official characteristics

preserve

bysort city_ch: keep if _n == 1

sum faction age male minor college wkexp dispatch lateral tenure shareht sharesch sharewp, sep(0)

restore

* City characteristics

preserve

bysort city_ch: keep if _n == 1

sum citysort1 citysort2 gdppc gdpg pdensity fiscal hlthworker, sep(0)

restore

* City-day variables

sum confn14 d_movewithin d_movein d_moveout bdindexS7 wdsp temp prcp, sep(0)
